-
Re: can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)
Yes. This formula will essentially output a date that is 7 days past [Start Date]@row and will increment every 7 days. So basically it will output the date 1 week from the original date. Once that fi…1 · -
Re: Viewing an Approval Request is Auto-Declining that Request
You may want to reach out to Support.1 · -
Re: Viewing an Approval Request is Auto-Declining that Request
Is the approval request being sent to more than one person?1 · -
Re: Return sum of one column if today's date is between A and B, etc
While this is technically correct, there are actually a number of ways to make this easier for you. The most immediate is by removing the need to hard code whether a month has 28, 29, 30, or 31 days …1 · -
Re: Calculate the sum for each month.
@NickStaffordPM You can use the criteria from my formula in same sheet formulas as well to avoid needing the extra columns. =SUMIFS(Cost:Cost, Status:Status, @cell = "STARTED", Date:Date, A…1 ·